﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Utils
{
    /// <summary>
    /// define const here
    /// </summary>
    public static class ConstUtils
    {
        //const value
        public static string V_SampleUrl = "http://juicybasket.com";
        public static string V_SampleEmail = "hello@juicybasket.com";

        public static string V_Exists = "Exists";
        //session name
        public static string S_PreviousStep_Success = "PreviousStep_Success";
        public static string S_Notification_Success = "Notification_Success";
        public static string S_Notification_Error = "Notifcation_Error";
        //cookie name
        public static string C_JobToken = "JobToken"; //for post job, it contains "JobGUID-JobID" pair

        //the prefix 'SP_' means stored procedure
        public static string SP_GetLoginByID = "GetLoginByID";
        public static string SP_GetLoginByEmail = "GetLoginByEmail";
        public static string SP_GetLoginByUserName = "GetLoginByUserName";
        public static string SP_GetAccountType = "GetAccountType";
        public static string SP_GetUserName = "GetUserName";
        public static string SP_CheckUserNameAndEmail = "CheckUserNameAndEmail";
        public static string SP_InsertLoginAndInd = "InsertLoginAndInd";
        public static string SP_InsertEmailMessage = "InsertEmailLog";
        public static string SP_GetEmailTemplateByType = "GetEmailTemplateByType";
        public static string SP_GetEmailTemplateByID = "GetEmailTemplateByID";
        public static string SP_UpdateEmailTemplate = "UpdateEmailTemplate";
        public static string SP_InsertEmailTemplate = "InsertEmailTemplate";
        public static string SP_DeleteEmailTemplate = "DeleteEmailTemplate";
        public static string SP_UpdateEmailConfirmed = "UpdateEmailConfirmed";
        public static string SP_GetLoginAndIndByUserName = "GetLoginAndIndByUserName";
        public static string SP_GetLoginAndIndByIndID = "GetLoginAndIndByIndID";
        public static string SP_GetLoginAndInd = "GetLoginAndInd";
        public static string SP_GetLoginAndCo = "GetLoginAndCo";
        public static string SP_UpdateEmailConfirmationKey = "UpdateEmailConfirmationKey";
        public static string SP_UpdateLoginAndInd = "UpdateLoginAndInd";
        public static string SP_UpdateLoginAndCo = "UpdateLoginAndCo";
        public static string SP_InsertShot = "InsertShot";
        public static string SP_UpdateAvatar = "UpdateAvatar";
        public static string SP_GetSkillListByID = "GetSkillListByID";
        public static string SP_InsertSkill = "InsertSkill";
        public static string SP_DeleteSkill = "DeleteSkill";
        public static string SP_GetIndSkillCount = "GetIndSkillCount";
        public static string SP_GetIndJobTypeList = "GetIndJobTypeList";
        public static string SP_GetInd = "GetInd";
        public static string SP_GetCo = "GetCo";
        public static string SP_UpdateIndResume = "UpdateIndResume";
        public static string SP_UpdatePassword = "UpdatePassword";
        public static string SP_UpdatePasswordByEmailAndKey = "UpdatePasswordByEmailAndKey";
        public static string SP_UpdatePasswordResetKey = "UpdatePasswordResetKey";
        public static string SP_CheckPasswordResetKey = "CheckPasswordResetKey";
        public static string SP_GetShotTagListByID = "GetShotTagListByID";
        public static string SP_GetShotTagCount = "GetShotTagCount";
        public static string SP_InsertShotTag = "InsertShotTag";
        public static string SP_DeleteShotTag = "DeleteShotTag";
        public static string SP_GetShot = "GetShot";
        public static string SP_UpdateShot = "UpdateShot";
        public static string SP_DeleteShot = "DeleteShot";
        public static string SP_GetShotsByID = "GetShotsByID";
        public static string SP_GetShotsByIDAndTag = "GetShotsByIDAndTag";
        public static string SP_DeleteAccount = "DeleteAccount";
        public static string SP_GetShotTagStatCountByID = "GetShotTagStatCountByID";
        public static string SP_GetMostUsedShotTagStatCountByID = "GetMostUsedShotTagStatCountByID";
        public static string SP_GetShotForDisplaying = "GetShotForDisplaying";
        public static string SP_GetShotNeighbor = "GetShotNeighbor";
        public static string SP_GetCoJobByJobTokenAndCoID = "GetCoJobByJobTokenAndCoID";
        public static string SP_GetJobExpList = "GetJobExpList";
        public static string SP_GetJobTypeList = "GetJobTypeList";
        public static string SP_GetCoTypeList = "GetCoTypeList";
        public static string SP_InsertCoAndInsertJob = "InsertCoAndInsertJob";
        public static string SP_UpdateJobAndUpdateCo = "UpdateJobAndUpdateCo";
        public static string SP_UpdateCoAndInsertJob = "UpdateCoAndInsertJob";

        public static string SP_InsertLoginAndUpdateCoAndJob = "InsertLoginAndUpdateCoAndJob";
        public static string SP_InsertBillingInfo = "InsertBillingInfo";

        public static string SP_GetJobListByCoID = "GetJobListByCoID";
        public static string SP_GetJobForEdit = "GetJobForEdit";
        public static string SP_UpdateJobForEdit = "UpdateJobForEdit";
        public static string SP_UpdateJobCredits = "UpdateJobCredits";
        public static string SP_UpdateCoAndJob = "UpdateCoAndJob";
        public static string SP_UpdateJobCreditsAndStatus = "UpdateJobCreditsAndStatus";
        public static string SP_GetCoJobByJobID = "GetCoJobByJobID";
        public static string SP_GetBillingInfoByLoginID = "GetBillingInfoByLoginID";

        public static string SP_GetOneSavedJob = "GetOneSavedJob";
        public static string SP_InsertSavedJob = "InsertSavedJob";
        public static string SP_DeleteSavedJob = "DeleteSavedJob";
        public static string SP_GetOneSavedInd = "GetOneSavedInd";
        public static string SP_InsertSavedInd = "InsertSavedInd";
        public static string SP_DeleteSavedInd = "DeleteSavedInd";
        public static string SP_GetOneEmailLog = "GetOneEmailLog";
        public static string SP_GetOneEmailLogByUserName = "GetOneEmailLogByUserName";
        public static string SP_GetSavedTalentAndShotList = "GetSavedTalentAndShotList";
        public static string SP_GetSavedJob = "GetSavedJob";
        public static string SP_GetCoListByIDs = "GetCoListByIDs";
        public static string SP_GetLatestJobs = "GetLatestJobs";
        public static string SP_GetLatestShots = "GetLatestShots";
        public static string SP_SearchJobs = "SearchJobs";
    }
}
